package com.fake_Interviews.Mapper;

import com.fake_Interviews.module.Interviews;
import com.fake_Interviews.module.InterviewsExample;

import java.util.List;

import com.fake_Interviews.module.Login;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface InterviewsMapper {
    //    根据面试官id查询面试表记录集合
    @Select("select * from `Interviews` where `Interviewer` = #{id}")
    List<Interviews> getInterviewsById(int id);

    //    将面试时间进行排序
    @Select("select * from interviews WHERE Status is not false order by InterviewTime asc")
    List<Interviews> TimeSortBy();

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    long countByExample(InterviewsExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int deleteByExample(InterviewsExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int insert(Interviews record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int insertSelective(Interviews record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    List<Interviews> selectByExample(InterviewsExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    Interviews selectByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int updateByExampleSelective(@Param("record") Interviews record, @Param("example") InterviewsExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int updateByExample(@Param("record") Interviews record, @Param("example") InterviewsExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int updateByPrimaryKeySelective(Interviews record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table interviews
     *
     * @mbg.generated Tue Aug 23 21:51:09 CST 2022
     */
    int updateByPrimaryKey(Interviews record);
}
